subscribers

Dataset statistics

Number of variables	30
Number of observations	227628
Missing cells	941504
Missing cells (%)	13.8%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	47.5 MiB
Average record size in memory	219.0 B

Variable types

CAT	18
NUM	8
BOOL	4

Warnings

`country` has constant value "227628"	Constant
`months_per_bill_period` has constant value "227628"	Constant
`language` has constant value "227628"	Constant
`account_creation_date` has a high cardinality: 226023 distinct values	High cardinality
`trial_end_date` has a high cardinality: 226023 distinct values	High cardinality
`last_payment` has a high cardinality: 131339 distinct values	High cardinality
`next_payment` has a high cardinality: 129206 distinct values	High cardinality
`cancel_date` has a high cardinality: 284 distinct values	High cardinality
`discount_price` is highly correlated with `monthly_price` and 1 other fields	High correlation
`monthly_price` is highly correlated with `discount_price` and 1 other fields	High correlation
`num_trial_days` is highly correlated with `monthly_price` and 1 other fields	High correlation
`num_trial_days` is highly correlated with `plan_type`	High correlation
`plan_type` is highly correlated with `num_trial_days`	High correlation
`package_type` has 35574 (15.6%) missing values	Missing
`num_weekly_services_utilized` has 110450 (48.5%) missing values	Missing
`preferred_genre` has 36326 (16.0%) missing values	Missing
`intended_use` has 3549 (1.6%) missing values	Missing
`weekly_consumption_hour` has 37930 (16.7%) missing values	Missing
`num_ideal_streaming_services` has 112170 (49.3%) missing values	Missing
`age` has 35169 (15.5%) missing values	Missing
`attribution_survey` has 2644 (1.2%) missing values	Missing
`op_sys` has 13375 (5.9%) missing values	Missing
`join_fee` has 34904 (15.3%) missing values	Missing
`payment_type` has 135578 (59.6%) missing values	Missing
`last_payment` has 95391 (41.9%) missing values	Missing
`next_payment` has 97378 (42.8%) missing values	Missing
`cancel_date` has 190797 (83.8%) missing values	Missing
`age` is highly skewed (γ1 = 403.3291721)	Skewed
`monthly_price` is highly skewed (γ1 = -35.47057095)	Skewed
`discount_price` is highly skewed (γ1 = -34.15730579)	Skewed
`account_creation_date` is uniformly distributed	Uniform
`trial_end_date` is uniformly distributed	Uniform
`last_payment` is uniformly distributed	Uniform
`next_payment` is uniformly distributed	Uniform
`subid` has unique values	Unique
`join_fee` has 33482 (14.7%) zeros	Zeros

Reproduction

Analysis started	2020-12-04 13:26:07.485832
Analysis finished	2020-12-04 13:26:39.172769
Duration	31.69 seconds
Software version	pandas-profiling v2.9.0
Download configuration	config.yaml

subid
Real number (ℝ_≥0)

UNIQUE

Distinct	227628
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	24986239.81
Minimum	20000009
Maximum	29999982
Zeros	0
Zeros (%)	0.0%
Memory size	1.7 MiB

Quantile statistics

Minimum	20000009
5-th percentile	20496214.8
Q1	22489975.5
median	24970107.5
Q3	27490204.75
95-th percentile	29492191.3
Maximum	29999982
Range	9999973
Interquartile range (IQR)	5000229.25

Descriptive statistics

Standard deviation	2885543.308
Coefficient of variation (CV)	0.1154852963
Kurtosis	-1.199613914
Mean	24986239.81
Median Absolute Deviation (MAD)	2500579
Skewness	0.007929852742
Sum	5.687567796e+12
Variance	8.32636018e+12
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
24643583	1	< 0.1%
29903967	1	< 0.1%
22623344	1	< 0.1%
28429423	1	< 0.1%
21559392	1	< 0.1%
22670443	1	< 0.1%
20053097	1	< 0.1%
26866792	1	< 0.1%
27366500	1	< 0.1%
25991042	1	< 0.1%
Other values (227618)	227618	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
20000009	1	< 0.1%
20000048	1	< 0.1%
20000062	1	< 0.1%
20000094	1	< 0.1%
20000104	1	< 0.1%

Value	Count	Frequency (%)
29999982	1	< 0.1%
29999945	1	< 0.1%
29999904	1	< 0.1%
29999889	1	< 0.1%
29999879	1	< 0.1%

package_type
Categorical

MISSING

Distinct	3
Distinct (%)	< 0.1%
Missing	35574
Missing (%)	15.6%
Memory size	1.7 MiB

base	111464
enhanced	63241
economy	17349

Frequencies
Length

Value	Count	Frequency (%)
base	111464	49.0%
enhanced	63241	27.8%
economy	17349	7.6%
(Missing)	35574	15.6%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	8
Median length	4
Mean length	5.183672483
Min length	3

num_weekly_services_utilized
Real number (ℝ_≥0)

MISSING

Distinct	12
Distinct (%)	< 0.1%
Missing	110450
Missing (%)	48.5%
Infinite	0
Infinite (%)	0.0%

Mean	3.008824182
Minimum	0
Maximum	14
Zeros	2
Zeros (%)	< 0.1%
Memory size	1.7 MiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	2
median	3
Q3	3
95-th percentile	5
Maximum	14
Range	14
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.8205257244
Coefficient of variation (CV)	0.2727064377
Kurtosis	2.350893503
Mean	3.008824182
Median Absolute Deviation (MAD)	0
Skewness	1.022780299
Sum	352568
Variance	0.6732624644
Monotocity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
3	63944	28.1%
2	29773	13.1%
4	17323	7.6%
5	5033	2.2%
6	904	0.4%
7	138	0.1%
1	24	< 0.1%
8	22	< 0.1%
9	11	< 0.1%
10	3	< 0.1%
Other values (2)	3	< 0.1%
(Missing)	110450	48.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2	< 0.1%
1	24	< 0.1%
2	29773	13.1%
3	63944	28.1%
4	17323	7.6%

Value	Count	Frequency (%)
14	1	< 0.1%
10	3	< 0.1%
9	11	< 0.1%
8	22	< 0.1%
7	138	0.1%

preferred_genre
Categorical

MISSING

Distinct	5
Distinct (%)	< 0.1%
Missing	36326
Missing (%)	16.0%
Memory size	1.7 MiB

comedy	125129
drama	46872
regional	8990
international	6404
other	3907

Frequencies
Length

Value	Count	Frequency (%)
comedy	125129	55.0%
drama	46872	20.6%
regional	8990	3.9%
international	6404	2.8%
other	3907	1.7%
(Missing)	36326	16.0%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	13
Median length	6
Mean length	5.574090182
Min length	3

intended_use
Categorical

MISSING

Distinct	7
Distinct (%)	< 0.1%
Missing	3549
Missing (%)	1.6%
Memory size	1.7 MiB

access to exclusive content	89039
replace OTT	69185
supplement OTT	26603
expand regional access	14025
expand international access	12978
Other values (2)	12249

Frequencies
Length

Value	Count	Frequency (%)
access to exclusive content	89039	39.1%
replace OTT	69185	30.4%
supplement OTT	26603	11.7%
expand regional access	14025	6.2%
expand international access	12978	5.7%
other	7112	3.1%
education	5137	2.3%
(Missing)	3549	1.6%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	27
Median length	22
Mean length	18.84182087
Min length	3

weekly_consumption_hour
Real number (ℝ)

MISSING

Distinct	81
Distinct (%)	< 0.1%
Missing	37930
Missing (%)	16.7%
Infinite	0
Infinite (%)	0.0%

Mean	27.99772411
Minimum	-32.1467596
Maximum	76.59996225
Zeros	0
Zeros (%)	0.0%
Memory size	1.7 MiB

Quantile statistics

Minimum	-32.1467596
5-th percentile	21.50162318
Q1	24.40153577
median	27.30144835
Q3	30.20136093
95-th percentile	37.45114239
Maximum	76.59996225
Range	108.7467219
Interquartile range (IQR)	5.799825165

Descriptive statistics

Standard deviation	4.976340586
Coefficient of variation (CV)	0.1777408966
Kurtosis	3.166855179
Mean	27.99772411
Median Absolute Deviation (MAD)	2.899912583
Skewness	0.6415334006
Sum	5311112.268
Variance	24.76396563
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
25.85149206	25990	11.4%
28.75140464	22947	10.1%
27.30144835	22551	9.9%
24.40153577	19968	8.8%
30.20136093	18366	8.1%
22.95157947	16839	7.4%
31.65131722	13262	5.8%
33.10127351	9411	4.1%
21.50162318	8720	3.8%
34.5512298	7424	3.3%
Other values (71)	24220	10.6%
(Missing)	37930	16.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-32.1467596	1	< 0.1%
-29.24684701	4	< 0.1%
-27.79689072	1	< 0.1%
-23.44702185	1	< 0.1%
-13.29732781	1	< 0.1%

Value	Count	Frequency (%)
76.59996225	3	< 0.1%
75.15000596	3	< 0.1%
73.70004967	1	< 0.1%
72.25009338	5	< 0.1%
67.90022451	5	< 0.1%

num_ideal_streaming_services
Real number (ℝ)

MISSING

Distinct	8
Distinct (%)	< 0.1%
Missing	112170
Missing (%)	49.3%
Infinite	0
Infinite (%)	0.0%

Mean	2.061260372
Minimum	-1
Maximum	7
Zeros	4
Zeros (%)	< 0.1%
Memory size	1.7 MiB

Quantile statistics

Minimum	-1
5-th percentile	2
Q1	2
median	2
Q3	2
95-th percentile	3
Maximum	7
Range	8
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.2459068491
Coefficient of variation (CV)	0.1192992659
Kurtosis	14.18046344
Mean	2.061260372
Median Absolute Deviation (MAD)	0
Skewness	3.601631299
Sum	237989
Variance	0.06047017843
Monotocity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
2	108245	47.6%
3	7072	3.1%
1	89	< 0.1%
4	42	< 0.1%
5	4	< 0.1%
0	4	< 0.1%
7	1	< 0.1%
-1	1	< 0.1%
(Missing)	112170	49.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1	1	< 0.1%
0	4	< 0.1%
1	89	< 0.1%
2	108245	47.6%
3	7072	3.1%

Value	Count	Frequency (%)
7	1	< 0.1%
5	4	< 0.1%
4	42	< 0.1%
3	7072	3.1%
2	108245	47.6%

age
Real number (ℝ_≥0)

MISSING
SKEWED

Distinct	278
Distinct (%)	0.1%
Missing	35169
Missing (%)	15.5%
Infinite	0
Infinite (%)	0.0%

Mean	757.9754574
Minimum	0
Maximum	81720000
Zeros	64
Zeros (%)	< 0.1%
Memory size	1.7 MiB

Quantile statistics

Minimum	0
5-th percentile	24
Q1	35
median	46
Q3	57
95-th percentile	70
Maximum	81720000
Range	81720000
Interquartile range (IQR)	22

Descriptive statistics

Standard deviation	192020.4428
Coefficient of variation (CV)	253.3333248
Kurtosis	170584.1771
Mean	757.9754574
Median Absolute Deviation (MAD)	11
Skewness	403.3291721
Sum	145879198.6
Variance	3.687185044e+10
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
50	6355	2.8%
40	5509	2.4%
60	5221	2.3%
48	4651	2.0%
47	4517	2.0%
55	4509	2.0%
49	4483	2.0%
52	4440	2.0%
43	4357	1.9%
42	4346	1.9%
Other values (268)	144071	63.3%
(Missing)	35169	15.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	64	< 0.1%
10	3	< 0.1%
16	1	< 0.1%
18	1097	0.5%
19	632	0.3%

Value	Count	Frequency (%)
81720000	1	< 0.1%
11022000	1	< 0.1%
10301949	1	< 0.1%
8121930	1	< 0.1%
8061990	1	< 0.1%

male_TF
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	269
Missing (%)	0.1%
Memory size	1.7 MiB

False	200902
True	26457
(Missing)	269

Common Values
Chart

Value	Count	Frequency (%)
False	200902	88.3%
True	26457	11.6%
(Missing)	269	0.1%

country
Categorical

CONSTANT
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.7 MiB

UAE	227628

Frequencies
Length

Value	Count	Frequency (%)
UAE	227628	100.0%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	3
Median length	3
Mean length	3
Min length	3

attribution_technical
Categorical

Distinct	33
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.7 MiB

facebook	80251
email	25690
search	25306
organic	22013
brand sem intent google	18524
Other values (28)	55844

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
facebook	80251	35.3%
email	25690	11.3%
search	25306	11.1%
organic	22013	9.7%
brand sem intent google	18524	8.1%
google_organic	10691	4.7%
affiliate	9894	4.3%
email_blast	7277	3.2%
pinterest	6065	2.7%
referral	5170	2.3%
Other values (23)	16747	7.4%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	23
Median length	8
Mean length	9.204082977
Min length	2

attribution_survey
Categorical

MISSING

Distinct	16
Distinct (%)	< 0.1%
Missing	2644
Missing (%)	1.2%
Memory size	1.7 MiB

facebook	119126
tv	39904
referral	20882
search	8492
pinterest	7856
Other values (11)	28724

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
facebook	119126	52.3%
tv	39904	17.5%
referral	20882	9.2%
search	8492	3.7%
pinterest	7856	3.5%
other	6496	2.9%
public_radio	6219	2.7%
social_organic	3869	1.7%
youtube	3108	1.4%
podcast	2995	1.3%
Other values (6)	6037	2.7%
(Missing)	2644	1.2%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	16
Median length	8
Mean length	6.965918077
Min length	2

op_sys
Categorical

MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	13375
Missing (%)	5.9%
Memory size	1.7 MiB

iOS	143921
Android	70332

Frequencies
Length

Value	Count	Frequency (%)
iOS	143921	63.2%
Android	70332	30.9%
(Missing)	13375	5.9%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	7
Median length	3
Mean length	4.235911224
Min length	3

months_per_bill_period
Categorical

CONSTANT
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.7 MiB

4	227628

Frequencies
Length

Value	Count	Frequency (%)
4	227628	100.0%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

plan_type
Categorical

HIGH CORRELATION

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.7 MiB

base_uae_14_day_trial	227096
high_uae_14_day_trial	325
low_uae_no_trial	167
base_eur_14_day_trial	18
high_sar_14_day_trial	12
Other values (6)	10

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
base_uae_14_day_trial	227096	99.8%
high_uae_14_day_trial	325	0.1%
low_uae_no_trial	167	0.1%
base_eur_14_day_trial	18	< 0.1%
high_sar_14_day_trial	12	< 0.1%
low_gbp_14_day_trial	4	< 0.1%
high_aud_14_day_trial	2	< 0.1%
high_jpy_14_day_trial	1	< 0.1%
low_sar_no_trial	1	< 0.1%
low_eur_no_trial	1	< 0.1%

Frequencies of value counts

Unique

Unique	4 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	33
Median length	21
Mean length	20.99632295
Min length	16

monthly_price
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	4.732049419
Minimum	0.8074
Maximum	5.1013
Zeros	0
Zeros (%)	0.0%
Memory size	1.7 MiB

Quantile statistics

Minimum	0.8074
5-th percentile	4.7343
Q1	4.7343
median	4.7343
Q3	4.7343
95-th percentile	4.7343
Maximum	5.1013
Range	4.2939
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.1010488003
Coefficient of variation (CV)	0.02135413039
Kurtosis	1287.47917
Mean	4.732049419
Median Absolute Deviation (MAD)	0
Skewness	-35.47057095
Sum	1077146.945
Variance	0.01021086004
Monotocity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
4.7343	227101	99.8%
5.1013	325	0.1%
1.0643	167	0.1%
4.4407	18	< 0.1%
4.3673	12	< 0.1%
4.0003	2	< 0.1%
1.1744	1	< 0.1%
0.8074	1	< 0.1%
4.6976	1	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.8074	1	< 0.1%
1.0643	167	0.1%
1.1744	1	< 0.1%
4.0003	2	< 0.1%
4.3673	12	< 0.1%

Value	Count	Frequency (%)
5.1013	325	0.1%
4.7343	227101	99.8%
4.6976	1	< 0.1%
4.4407	18	< 0.1%
4.3673	12	< 0.1%

discount_price
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	4.512188481
Minimum	0.7707
Maximum	5.0279
Zeros	0
Zeros (%)	0.0%
Memory size	1.7 MiB

Quantile statistics

Minimum	0.7707
5-th percentile	4.5141
Q1	4.5141
median	4.5141
Q3	4.5141
95-th percentile	4.5141
Maximum	5.0279
Range	4.2572
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.09707790925
Coefficient of variation (CV)	0.02151459533
Kurtosis	1231.974423
Mean	4.512188481
Median Absolute Deviation (MAD)	0
Skewness	-34.15730579
Sum	1027100.44
Variance	0.009424120464
Monotocity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
4.5141	227096	99.8%
5.0279	325	0.1%
1.0276	167	0.1%
4.2205	18	< 0.1%
4.0737	12	< 0.1%
4.3673	4	< 0.1%
4.4407	2	< 0.1%
3.7801	2	< 0.1%
1.1744	1	< 0.1%
0.7707	1	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.7707	1	< 0.1%
1.0276	167	0.1%
1.1744	1	< 0.1%
3.7801	2	< 0.1%
4.0737	12	< 0.1%

Value	Count	Frequency (%)
5.0279	325	0.1%
4.5141	227096	99.8%
4.4407	2	< 0.1%
4.3673	4	< 0.1%
4.2205	18	< 0.1%

account_creation_date
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	226023
Distinct (%)	99.3%
Missing	0
Missing (%)	0.0%
Memory size	1.7 MiB

2020-03-14 18:22:06	3
2019-07-01 01:21:10	3
2020-02-29 17:58:30	3
2019-06-30 14:47:57	3
2019-11-17 16:24:52	3
Other values (226018)	227613

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
2020-03-14 18:22:06	3	< 0.1%
2019-07-01 01:21:10	3	< 0.1%
2020-02-29 17:58:30	3	< 0.1%
2019-06-30 14:47:57	3	< 0.1%
2019-11-17 16:24:52	3	< 0.1%
2019-07-02 14:58:45	3	< 0.1%
2020-02-29 19:26:26	3	< 0.1%
2019-11-30 02:48:10	3	< 0.1%
2019-12-28 16:35:34	3	< 0.1%
2020-03-15 20:09:50	2	< 0.1%
Other values (226013)	227599	> 99.9%

Frequencies of value counts

Unique

Unique	224427 ?
Unique (%)	98.6%

Histogram of lengths of the category

Length

Max length	19
Median length	19
Mean length	19
Min length	19

trial_end_date
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	226023
Distinct (%)	99.3%
Missing	0
Missing (%)	0.0%
Memory size	1.7 MiB

2020-01-11 16:35:34	3
2019-07-14 14:47:57	3
2019-12-14 02:48:10	3
2019-07-16 14:58:45	3
2019-12-01 16:24:52	3
Other values (226018)	227613

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
2020-01-11 16:35:34	3	< 0.1%
2019-07-14 14:47:57	3	< 0.1%
2019-12-14 02:48:10	3	< 0.1%
2019-07-16 14:58:45	3	< 0.1%
2019-12-01 16:24:52	3	< 0.1%
2020-03-14 19:26:26	3	< 0.1%
2020-03-28 18:22:06	3	< 0.1%
2019-07-15 01:21:10	3	< 0.1%
2020-03-14 17:58:30	3	< 0.1%
2019-12-10 00:24:38	2	< 0.1%
Other values (226013)	227599	> 99.9%

Frequencies of value counts

Unique

Unique	224427 ?
Unique (%)	98.6%

Histogram of lengths of the category

Length

Max length	19
Median length	19
Mean length	19
Min length	19

initial_credit_card_declined
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	222.3 KiB

False	216425
True	11203

Common Values
Chart

Value	Count	Frequency (%)
False	216425	95.1%
True	11203	4.9%

join_fee
Real number (ℝ)

MISSING
ZEROS

Distinct	20
Distinct (%)	< 0.1%
Missing	34904
Missing (%)	15.3%
Infinite	0
Infinite (%)	0.0%

Mean	0.1151453836
Minimum	-0.6606
Maximum	0.734
Zeros	33482
Zeros (%)	14.7%
Memory size	1.7 MiB

Quantile statistics

Minimum	-0.6606
5-th percentile	0
Q1	0.0367
median	0.0367
Q3	0.1101
95-th percentile	0.6606
Maximum	0.734
Range	1.3946
Interquartile range (IQR)	0.0734

Descriptive statistics

Standard deviation	0.1769706831
Coefficient of variation (CV)	1.536932507
Kurtosis	3.131999623
Mean	0.1151453836
Median Absolute Deviation (MAD)	0
Skewness	2.026261329
Sum	22191.2789
Variance	0.03131862266
Monotocity	Not monotonic

Histogram with fixed size bins (bins=20)

Value	Count	Frequency (%)
0.0367	109482	48.1%
0	33482	14.7%
0.3303	25314	11.1%
0.6606	12282	5.4%
0.1101	10648	4.7%
0.367	1333	0.6%
0.1835	146	0.1%
-0.0367	9	< 0.1%
0.6973	8	< 0.1%
0.6239	6	< 0.1%
Other values (10)	14	< 0.1%
(Missing)	34904	15.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-0.6606	2	< 0.1%
-0.3303	1	< 0.1%
-0.1101	1	< 0.1%
-0.0367	9	< 0.1%
0	33482	14.7%

Value	Count	Frequency (%)
0.734	1	< 0.1%
0.6973	8	< 0.1%
0.6606	12282	5.4%
0.6239	6	< 0.1%
0.5872	1	< 0.1%

language
Categorical

CONSTANT
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.7 MiB

ar	227628

Frequencies
Length

Value	Count	Frequency (%)
ar	227628	100.0%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	2
Median length	2
Mean length	2
Min length	2

payment_type
Categorical

MISSING

Distinct	6
Distinct (%)	< 0.1%
Missing	135578
Missing (%)	59.6%
Memory size	1.7 MiB

Standard Charter	38810
Paypal	30911
RAKBANK	14831
CBD	5080
Najim	2414

Frequencies
Length

Value	Count	Frequency (%)
Standard Charter	38810	17.0%
Paypal	30911	13.6%
RAKBANK	14831	6.5%
CBD	5080	2.2%
Najim	2414	1.1%
Apple Pay	4	< 0.1%
(Missing)	135578	59.6%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	16
Median length	3
Mean length	5.90578927
Min length	3

num_trial_days
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.7 MiB

14	227458
0	170

Frequencies
Length

Value	Count	Frequency (%)
14	227458	99.9%
0	170	0.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	2
Median length	2
Mean length	1.999253167
Min length	1

current_sub_TF
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	222.3 KiB

True	130250
False	97378

Common Values
Chart

Value	Count	Frequency (%)
True	130250	57.2%
False	97378	42.8%

payment_period
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.7 MiB

0	95391
1	86968
2	42921
3	2348

Frequencies
Length

Value	Count	Frequency (%)
0	95391	41.9%
1	86968	38.2%
2	42921	18.9%
3	2348	1.0%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

last_payment
Categorical

HIGH CARDINALITY
MISSING
UNIFORM

Distinct	131339
Distinct (%)	99.3%
Missing	95391
Missing (%)	41.9%
Memory size	1.7 MiB

2020-03-14 19:26:26	3
2020-03-08 19:00:43	3
2019-12-14 02:48:10	3
2020-02-29 12:16:18	3
2020-02-14 16:53:19	2
Other values (131334)	132223

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
2020-03-14 19:26:26	3	< 0.1%
2020-03-08 19:00:43	3	< 0.1%
2019-12-14 02:48:10	3	< 0.1%
2020-02-29 12:16:18	3	< 0.1%
2020-02-14 16:53:19	2	< 0.1%
2020-01-22 14:57:28	2	< 0.1%
2020-01-18 01:17:02	2	< 0.1%
2020-03-25 05:48:58	2	< 0.1%
2020-02-14 16:18:49	2	< 0.1%
2020-01-16 11:50:04	2	< 0.1%
Other values (131329)	132213	58.1%
(Missing)	95391	41.9%

Frequencies of value counts

Unique

Unique	130445 ?
Unique (%)	98.6%

Histogram of lengths of the category

Length

Max length	19
Median length	19
Mean length	12.29495493
Min length	3

next_payment
Categorical

HIGH CARDINALITY
MISSING
UNIFORM

Distinct	129206
Distinct (%)	99.2%
Missing	97378
Missing (%)	42.8%
Memory size	1.7 MiB

2020-07-08 19:00:43	3
2020-04-14 02:48:10	3
2020-03-28 18:22:06	3
2020-07-14 19:26:26	3
2020-06-29 12:16:18	3
Other values (129201)	130235

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
2020-07-08 19:00:43	3	< 0.1%
2020-04-14 02:48:10	3	< 0.1%
2020-03-28 18:22:06	3	< 0.1%
2020-07-14 19:26:26	3	< 0.1%
2020-06-29 12:16:18	3	< 0.1%
2020-05-24 21:19:34	2	< 0.1%
2020-05-12 16:04:44	2	< 0.1%
2020-06-24 23:09:50	2	< 0.1%
2020-04-02 15:12:04	2	< 0.1%
2020-04-13 19:44:04	2	< 0.1%
Other values (129196)	130225	57.2%
(Missing)	97378	42.8%

Frequencies of value counts

Unique

Unique	128167 ?
Unique (%)	98.4%

Histogram of lengths of the category

Length

Max length	19
Median length	19
Mean length	12.15528845
Min length	3

cancel_date
Categorical

HIGH CARDINALITY
MISSING

Distinct	284
Distinct (%)	0.8%
Missing	190797
Missing (%)	83.8%
Memory size	1.7 MiB

2019-07-13 00:00:00	431
2019-07-12 00:00:00	396
2019-07-14 00:00:00	384
2019-07-15 00:00:00	348
2019-07-11 00:00:00	321
Other values (279)	34951

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
2019-07-13 00:00:00	431	0.2%
2019-07-12 00:00:00	396	0.2%
2019-07-14 00:00:00	384	0.2%
2019-07-15 00:00:00	348	0.2%
2019-07-11 00:00:00	321	0.1%
2019-07-16 00:00:00	317	0.1%
2019-07-17 00:00:00	300	0.1%
2019-07-10 00:00:00	288	0.1%
2019-07-09 00:00:00	258	0.1%
2019-07-18 00:00:00	254	0.1%
Other values (274)	33534	14.7%
(Missing)	190797	83.8%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	19
Median length	3
Mean length	5.588855501
Min length	3

trial_completed
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	222.3 KiB

True	200236
False	27392

Common Values
Chart

Value	Count	Frequency (%)
True	200236	88.0%
False	27392	12.0%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

First rows

	subid	package_type	num_weekly_services_utilized	preferred_genre	intended_use	weekly_consumption_hour	num_ideal_streaming_services	age	male_TF	country	attribution_technical	attribution_survey	op_sys	months_per_bill_period	plan_type	monthly_price	discount_price	account_creation_date	trial_end_date	initial_credit_card_declined	join_fee	language	payment_type	num_trial_days	current_sub_TF	payment_period	last_payment	next_payment	cancel_date	trial_completed
0	21724479	economy	NaN	comedy	access to exclusive content	NaN	NaN	NaN	False	UAE	facebook	facebook	Android	4	base_uae_14_day_trial	4.7343	4.5141	2020-01-24 21:44:16	2020-02-07 21:44:16	False	NaN	ar	Standard Charter	14	True	1	2020-02-07 21:44:16	2020-06-07 21:44:16	NaN	True
1	23383224	base	NaN	comedy	access to exclusive content	22.951579	NaN	70.0	False	UAE	facebook	facebook	NaN	4	base_uae_14_day_trial	4.7343	4.5141	2020-03-01 15:44:35	2020-03-15 15:44:35	False	0.3303	ar	NaN	14	True	1	2020-03-15 15:44:35	2020-07-15 15:44:35	NaN	True
2	26844789	enhanced	3.0	regional	replace OTT	36.001186	2.0	25.0	True	UAE	organic	facebook	iOS	4	base_uae_14_day_trial	4.7343	4.5141	2019-12-07 16:37:06	2019-12-21 16:37:06	False	0.1101	ar	NaN	14	False	0	NaN	NaN	NaN	True
3	29417030	base	NaN	drama	replace OTT	20.051667	NaN	30.0	False	UAE	search	tv	Android	4	base_uae_14_day_trial	4.7343	4.5141	2020-01-27 16:09:32	2020-02-10 16:09:32	False	0.0367	ar	NaN	14	False	0	NaN	NaN	NaN	True
4	26723159	base	4.0	comedy	replace OTT	22.951579	3.0	28.0	False	UAE	discovery	youtube	iOS	4	base_uae_14_day_trial	4.7343	4.5141	2019-10-05 12:57:07	2019-10-19 12:57:07	False	0.0367	ar	NaN	14	True	2	2020-02-19 12:57:07	2020-06-19 12:57:07	NaN	True
5	24810928	base	NaN	comedy	access to exclusive content	20.051667	NaN	70.0	False	UAE	bing	tv	NaN	4	base_uae_14_day_trial	4.7343	4.5141	2020-03-03 20:15:43	2020-03-17 20:15:43	False	0.3303	ar	RAKBANK	14	True	1	2020-03-17 20:15:43	2020-07-17 20:15:43	NaN	True
6	29726122	base	2.0	comedy	access to exclusive content	20.051667	2.0	61.0	False	UAE	bing	search	Android	4	base_uae_14_day_trial	4.7343	4.5141	2020-02-19 18:30:15	2020-03-04 18:30:15	False	0.3303	ar	Standard Charter	14	True	1	2020-03-04 18:30:15	2020-07-04 18:30:15	NaN	True
7	20299962	base	3.0	drama	access to exclusive content	34.551230	2.0	23.0	False	UAE	email	referral	iOS	4	base_uae_14_day_trial	4.7343	4.5141	2020-03-05 14:52:22	2020-03-19 14:52:22	False	0.0000	ar	RAKBANK	14	True	1	2020-03-19 14:52:22	2020-07-19 14:52:22	NaN	True
8	24930568	base	NaN	comedy	access to exclusive content	25.851492	NaN	73.0	False	UAE	facebook	facebook	iOS	4	base_uae_14_day_trial	4.7343	4.5141	2020-02-23 17:50:25	2020-03-08 17:50:25	False	0.6606	ar	NaN	14	True	1	2020-03-08 17:50:25	2020-07-08 17:50:25	NaN	True
9	23452753	economy	3.0	drama	replace OTT	28.751405	2.0	71.0	False	UAE	search	facebook	Android	4	base_uae_14_day_trial	4.7343	4.5141	2020-01-21 14:17:53	2020-02-04 14:17:53	False	0.3303	ar	NaN	14	False	0	NaN	NaN	2020-01-27 00:00:00	False

Last rows

	subid	package_type	num_weekly_services_utilized	preferred_genre	intended_use	weekly_consumption_hour	num_ideal_streaming_services	age	male_TF	country	attribution_technical	attribution_survey	op_sys	months_per_bill_period	plan_type	monthly_price	discount_price	account_creation_date	trial_end_date	initial_credit_card_declined	join_fee	language	payment_type	num_trial_days	current_sub_TF	payment_period	last_payment	next_payment	cancel_date	trial_completed
227618	22218943	economy	NaN	comedy	replace OTT	37.451142	NaN	67.0	True	UAE	brand sem intent bing	referral	iOS	4	base_uae_14_day_trial	4.7343	4.5141	2019-11-16 02:53:50	2019-11-30 02:53:50	False	0.0367	ar	NaN	14	False	0	NaN	NaN	2019-11-27 00:00:00	False
227619	25492551	base	3.0	comedy	access to exclusive content	30.201361	2.0	32.0	False	UAE	email	facebook	Android	4	base_uae_14_day_trial	4.7343	4.5141	2019-09-30 22:07:37	2019-10-14 22:07:37	False	0.0000	ar	NaN	14	True	2	2020-02-14 22:07:37	2020-06-14 22:07:37	NaN	True
227620	21928274	base	NaN	drama	replace OTT	NaN	NaN	NaN	False	UAE	facebook	facebook	Android	4	base_uae_14_day_trial	4.7343	4.5141	2020-01-14 02:04:52	2020-01-28 02:04:52	False	NaN	ar	RAKBANK	14	False	0	NaN	NaN	NaN	True
227621	25549852	enhanced	NaN	comedy	access to exclusive content	28.751405	NaN	61.0	False	UAE	affiliate	facebook	Android	4	base_uae_14_day_trial	4.7343	4.5141	2020-03-06 02:57:03	2020-03-20 02:57:03	False	0.3303	ar	NaN	14	True	1	2020-03-20 02:57:03	2020-07-20 02:57:03	NaN	True
227622	25835684	base	2.0	drama	access to exclusive content	24.401536	2.0	43.0	False	UAE	email	pinterest	iOS	4	base_uae_14_day_trial	4.7343	4.5141	2020-01-01 22:43:56	2020-01-15 22:43:56	False	0.0000	ar	NaN	14	True	1	2020-01-15 22:43:56	2020-05-15 22:43:56	NaN	True
227623	21434712	enhanced	3.0	comedy	supplement OTT	28.751405	2.0	38.0	False	UAE	facebook	facebook_organic	iOS	4	base_uae_14_day_trial	4.7343	4.5141	2019-11-17 14:12:33	2019-12-01 14:12:33	False	0.3303	ar	NaN	14	True	1	2019-12-01 14:12:33	2020-04-01 14:12:33	NaN	True
227624	25843074	enhanced	2.0	comedy	replace OTT	27.301448	2.0	49.0	False	UAE	google_organic	referral	iOS	4	base_uae_14_day_trial	4.7343	4.5141	2019-12-06 18:02:13	2019-12-20 18:02:13	False	0.3303	ar	Paypal	14	True	1	2019-12-20 18:02:13	2020-04-20 18:02:13	NaN	True
227625	24799085	base	NaN	comedy	access to exclusive content	31.651317	NaN	45.0	False	UAE	facebook	facebook	iOS	4	base_uae_14_day_trial	4.7343	4.5141	2019-12-21 19:40:44	2020-01-04 19:40:44	True	0.0367	ar	NaN	14	True	1	2020-01-04 19:40:44	2020-05-04 19:40:44	NaN	True
227626	21308040	base	NaN	comedy	access to exclusive content	NaN	NaN	NaN	False	UAE	facebook	facebook	iOS	4	base_uae_14_day_trial	4.7343	4.5141	2020-01-17 23:58:51	2020-01-31 23:58:51	False	NaN	ar	Paypal	14	True	1	2020-01-31 23:58:51	2020-05-31 23:58:51	NaN	True
227627	20166335	base	NaN	comedy	replace OTT	25.851492	NaN	55.0	False	UAE	organic	tv	iOS	4	base_uae_14_day_trial	4.7343	4.5141	2019-11-26 19:09:09	2019-12-10 19:09:09	False	0.0367	ar	NaN	14	False	0	NaN	NaN	2019-12-09 00:00:00	False

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows